package cabbage.database.idao;

import java.sql.SQLException;

public interface ICollectibleDAO {
	
	public int createCollectible(int itemid, int skillid, int facultyid,
			String name, int collectiblecategoryid, String description, String imagefilename) throws SQLException;
	
	public int createFaculty() throws SQLException;
	
	public int createSkill(int facultyid) throws SQLException;
	
	public int createItem(int skillid, int facultyid) throws SQLException;
	
	public boolean checkCollectibleidCategoryExists(int id) throws SQLException;
	
	public boolean checkCollectibleMasteridExists(int id) throws SQLException;
	
	public boolean checkFacultyidExists(int id) throws SQLException;
	
	public boolean checkSkillidExists(int id) throws SQLException;
	
	public boolean checkItemidExists(int id) throws SQLException;
	
	public boolean checkCollectibleNameExists(String name) throws SQLException;
	
	

}
